Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 26969 |
| Missing cells | 32 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.8 MiB |
| Average record size in memory | 224.0 B |
Variable types
| CAT | 16 |
|---|---|
| NUM | 10 |
| BOOL | 2 |
Reproduction
| Analysis started | 2020-09-21 17:00:31.509054 |
|---|---|
| Analysis finished | 2020-09-21 17:00:59.720593 |
| Duration | 28.21 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
df_index has constant value "0" | Constant |
Date & Time has a high cardinality: 22997 distinct values | High cardinality |
Type of aircraft has a high cardinality: 1085 distinct values | High cardinality |
Operator has a high cardinality: 7837 distinct values | High cardinality |
Registration has a high cardinality: 25839 distinct values | High cardinality |
Schedule has a high cardinality: 14646 distinct values | High cardinality |
MSN has a high cardinality: 17759 distinct values | High cardinality |
Location has a high cardinality: 12845 distinct values | High cardinality |
Country has a high cardinality: 218 distinct values | High cardinality |
Circumstances has a high cardinality: 21207 distinct values | High cardinality |
FlightDate has a high cardinality: 17590 distinct values | High cardinality |
FlightOperator has a high cardinality: 7836 distinct values | High cardinality |
src_rowid is highly correlated with rowid | High correlation |
rowid is highly correlated with src_rowid | High correlation |
Total fatalities is highly correlated with Pax fatalities | High correlation |
Pax fatalities is highly correlated with Total fatalities | High correlation |
Crew on board is highly skewed (γ1 = 149.7973589) | Skewed |
Other fatalities is highly skewed (γ1 = 61.95186755) | Skewed |
Date & Time is uniformly distributed | Uniform |
Registration is uniformly distributed | Uniform |
FlightDate is uniformly distributed | Uniform |
rowid has unique values | Unique |
src_rowid has unique values | Unique |
dt has unique values | Unique |
Crew on board has 3480 (12.9%) zeros | Zeros |
Crew fatalities has 13596 (50.4%) zeros | Zeros |
Pax on board has 14091 (52.2%) zeros | Zeros |
Pax fatalities has 20401 (75.6%) zeros | Zeros |
Other fatalities has 26634 (98.8%) zeros | Zeros |
Total fatalities has 11108 (41.2%) zeros | Zeros |
PlaneAge has 1979 (7.3%) zeros | Zeros |
| Distinct count | 26969 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13485.041232526233 |
|---|---|
| Minimum | 1 |
| Maximum | 26970 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1349.4 |
| Q1 | 6743 |
| median | 13485 |
| Q3 | 20227 |
| 95-th percentile | 25620.6 |
| Maximum | 26970 |
| Range | 26969 |
| Interquartile range (IQR) | 13484 |
Descriptive statistics
| Standard deviation | 7785.492517 |
|---|---|
| Coefficient of variation (CV) | 0.5773428781 |
| Kurtosis | -1.199966116 |
| Mean | 13485.04123 |
| Median Absolute Deviation (MAD) | 6742 |
| Skewness | 2.795850132e-05 |
| Sum | 363678077 |
| Variance | 60613893.73 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 7529 | 1 | < 0.1% | |
| 3371 | 1 | < 0.1% | |
| 13612 | 1 | < 0.1% | |
| 15661 | 1 | < 0.1% | |
| 9518 | 1 | < 0.1% | |
| 11567 | 1 | < 0.1% | |
| 21824 | 1 | < 0.1% | |
| 23873 | 1 | < 0.1% | |
| 17730 | 1 | < 0.1% | |
| Other values (26959) | 26959 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 26970 | 1 | < 0.1% | |
| 26969 | 1 | < 0.1% | |
| 26968 | 1 | < 0.1% | |
| 26967 | 1 | < 0.1% | |
| 26966 | 1 | < 0.1% |
| Distinct count | 26969 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13485.041232526233 |
|---|---|
| Minimum | 1 |
| Maximum | 26970 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1349.4 |
| Q1 | 6743 |
| median | 13485 |
| Q3 | 20227 |
| 95-th percentile | 25620.6 |
| Maximum | 26970 |
| Range | 26969 |
| Interquartile range (IQR) | 13484 |
Descriptive statistics
| Standard deviation | 7785.492517 |
|---|---|
| Coefficient of variation (CV) | 0.5773428781 |
| Kurtosis | -1.199966116 |
| Mean | 13485.04123 |
| Median Absolute Deviation (MAD) | 6742 |
| Skewness | 2.795850132e-05 |
| Sum | 363678077 |
| Variance | 60613893.73 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 7529 | 1 | < 0.1% | |
| 3371 | 1 | < 0.1% | |
| 13612 | 1 | < 0.1% | |
| 15661 | 1 | < 0.1% | |
| 9518 | 1 | < 0.1% | |
| 11567 | 1 | < 0.1% | |
| 21824 | 1 | < 0.1% | |
| 23873 | 1 | < 0.1% | |
| 17730 | 1 | < 0.1% | |
| Other values (26959) | 26959 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 26970 | 1 | < 0.1% | |
| 26969 | 1 | < 0.1% | |
| 26968 | 1 | < 0.1% | |
| 26967 | 1 | < 0.1% | |
| 26966 | 1 | < 0.1% |
| Distinct count | 26969 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| 2020-09-20 20:45:25.443000 | 1 |
|---|---|
| 2020-09-20 18:37:07.430000 | 1 |
| 2020-09-20 15:16:08.957000 | 1 |
| 2020-09-20 17:10:10.123000 | 1 |
| 2020-09-20 22:00:30.400000 | 1 |
| Other values (26964) |
| Value | Count | Frequency (%) | |
| 2020-09-20 20:45:25.443000 | 1 | < 0.1% | |
| 2020-09-20 18:37:07.430000 | 1 | < 0.1% | |
| 2020-09-20 15:16:08.957000 | 1 | < 0.1% | |
| 2020-09-20 17:10:10.123000 | 1 | < 0.1% | |
| 2020-09-20 22:00:30.400000 | 1 | < 0.1% | |
| 2020-09-20 16:43:52.020000 | 1 | < 0.1% | |
| 2020-09-20 19:34:38.747000 | 1 | < 0.1% | |
| 2020-09-20 15:25:45.630000 | 1 | < 0.1% | |
| 2020-09-20 19:12:37.950000 | 1 | < 0.1% | |
| 2020-09-20 16:21:36.657000 | 1 | < 0.1% | |
| Other values (26959) | 26959 | > 99.9% |
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 25.97041047 |
| Min length | 19 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 26969 | 100.0% |
| Distinct count | 22997 |
|---|---|
| Unique (%) | 85.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Mar 24, 1945 | 15 |
|---|---|
| Mar 6, 1944 | 11 |
| Jun 6, 1944 | 10 |
| Dec 18, 1939 | 10 |
| Dec 31, 1935 | 9 |
| Other values (22992) |
| Value | Count | Frequency (%) | |
| Mar 24, 1945 | 15 | 0.1% | |
| Mar 6, 1944 | 11 | < 0.1% | |
| Jun 6, 1944 | 10 | < 0.1% | |
| Dec 18, 1939 | 10 | < 0.1% | |
| Dec 31, 1935 | 9 | < 0.1% | |
| Sep 16, 1943 | 9 | < 0.1% | |
| Mar 24, 1944 | 8 | < 0.1% | |
| Apr 16, 1944 | 8 | < 0.1% | |
| Jul 11, 1943 | 8 | < 0.1% | |
| Jan 6, 1945 | 7 | < 0.1% | |
| Other values (22987) | 26874 | 99.6% |
Length
| Max length | 23 |
|---|---|
| Median length | 22 |
| Mean length | 17.28425229 |
| Min length | 11 |
| Distinct count | 1085 |
|---|---|
| Unique (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Douglas C-47 Skytrain (DC-3) | 2164 |
|---|---|
| PZL-Mielec AN-2 | 761 |
| Curtiss C-46 Commando | 634 |
| Avro 652 Anson | 532 |
| Douglas DC-3 | 423 |
| Other values (1080) |
| Value | Count | Frequency (%) | |
| Douglas C-47 Skytrain (DC-3) | 2164 | 8.0% | |
| PZL-Mielec AN-2 | 761 | 2.8% | |
| Curtiss C-46 Commando | 634 | 2.4% | |
| Avro 652 Anson | 532 | 2.0% | |
| Douglas DC-3 | 423 | 1.6% | |
| De Havilland DH.60 Moth | 357 | 1.3% | |
| De Havilland DHC-2 Beaver | 339 | 1.3% | |
| Piper PA-31-350 Navajo Chieftain | 333 | 1.2% | |
| Britten-Norman Islander | 328 | 1.2% | |
| Lockheed C-130 Hercules | 321 | 1.2% | |
| Other values (1075) | 20777 | 77.0% |
Length
| Max length | 43 |
|---|---|
| Median length | 21 |
| Mean length | 20.37713671 |
| Min length | 4 |
| Distinct count | 7837 |
|---|---|
| Unique (%) | 29.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Royal Air Force - RAF (31257) | 2247 |
|---|---|
| United States Air Force - USAF (since 1947) (31252) | 1443 |
| Aeroflot - Russian International Airlines (30808) | 1358 |
| United States Army Air Forces - USAAF (1941-1947) (39359) | 1350 |
| United States Navy - USN (37278) | 651 |
| Other values (7832) |
| Value | Count | Frequency (%) | |
| Royal Air Force - RAF (31257) | 2247 | 8.3% | |
| United States Air Force - USAF (since 1947) (31252) | 1443 | 5.4% | |
| Aeroflot - Russian International Airlines (30808) | 1358 | 5.0% | |
| United States Army Air Forces - USAAF (1941-1947) (39359) | 1350 | 5.0% | |
| United States Navy - USN (37278) | 651 | 2.4% | |
| Private American (31833) | 403 | 1.5% | |
| Royal Australian Air Force - RAAF (31800) | 267 | 1.0% | |
| French Air Force - Armée de l'Air (31256) | 191 | 0.7% | |
| Royal Canadian Air Force - RCAF (31234) | 175 | 0.6% | |
| Brazilian Air Force - Força Aérea Brasileira (31232) | 164 | 0.6% | |
| Other values (7827) | 18720 | 69.4% |
Length
| Max length | 98 |
|---|---|
| Median length | 32 |
| Mean length | 36.07504913 |
| Min length | 11 |
| Distinct count | 25839 |
|---|---|
| Unique (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| 2 | 6 |
|---|---|
| 1 | 6 |
| 48 | 5 |
| 29 | 5 |
| 1H+?S | 5 |
| Other values (25834) |
| Value | Count | Frequency (%) | |
| 2 | 6 | < 0.1% | |
| 1 | 6 | < 0.1% | |
| 48 | 5 | < 0.1% | |
| 29 | 5 | < 0.1% | |
| 1H+?S | 5 | < 0.1% | |
| 75 | 4 | < 0.1% | |
| 26 | 4 | < 0.1% | |
| 104 | 4 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 40 | 4 | < 0.1% | |
| Other values (25829) | 26922 | 99.8% |
Length
| Max length | 15 |
|---|---|
| Median length | 6 |
| Mean length | 6.217101116 |
| Min length | 1 |
Flight Phase
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Flight | |
|---|---|
| Landing (descent or approach) | |
| Takeoff (climb) | |
| Taxiing | 229 |
| Parking | 104 |
| Value | Count | Frequency (%) | |
| Flight | 10930 | 40.5% | |
| Landing (descent or approach) | 9808 | 36.4% | |
| Takeoff (climb) | 5898 | 21.9% | |
| Taxiing | 229 | 0.8% | |
| Parking | 104 | 0.4% |
Length
| Max length | 29 |
|---|---|
| Median length | 15 |
| Mean length | 16.34517409 |
| Min length | 6 |
Flight Type
Categorical
| Distinct count | 31 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Scheduled Revenue Flight | |
|---|---|
| Military | |
| Training | |
| Cargo | |
| Private | |
| Other values (26) |
| Value | Count | Frequency (%) | |
| Scheduled Revenue Flight | 6122 | 22.7% | |
| Military | 4476 | 16.6% | |
| Training | 3105 | 11.5% | |
| Cargo | 2719 | 10.1% | |
| Private | 1955 | 7.2% | |
| Charter/Taxi (Non Scheduled Revenue Flight) | 1594 | 5.9% | |
| Executive | 975 | 3.6% | |
| Survey / Patrol / Reconnaissance | 942 | 3.5% | |
| Bombing | 678 | 2.5% | |
| Positioning | 633 | 2.3% | |
| Other values (21) | 3770 | 14.0% |
Length
| Max length | 43 |
|---|---|
| Median length | 8 |
| Mean length | 14.74233379 |
| Min length | 4 |
Survivors
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Yes | |
|---|---|
| No |
| Value | Count | Frequency (%) | |
| Yes | 15275 | 56.6% | |
| No | 11694 | 43.4% |
Site
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Airport (less than 10 km from airport) | |
|---|---|
| Plain, Valley | |
| Lake, Sea, Ocean, River | |
| Mountains | |
| City | 443 |
| Value | Count | Frequency (%) | |
| Airport (less than 10 km from airport) | 13136 | 48.7% | |
| Plain, Valley | 6260 | 23.2% | |
| Lake, Sea, Ocean, River | 3633 | 13.5% | |
| Mountains | 3295 | 12.2% | |
| City | 443 | 1.6% | |
| Desert | 202 | 0.7% |
Length
| Max length | 38 |
|---|---|
| Median length | 23 |
| Mean length | 25.8350699 |
| Min length | 4 |
| Distinct count | 14646 |
|---|---|
| Unique (%) | 54.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 210.7 KiB |
| Point Cook - Point Cook | 49 |
|---|---|
| Mildenhall - Mildenhall | 47 |
| Waddington - Waddington | 47 |
| Paris - Croydon | 44 |
| Scampton - Scampton | 44 |
| Other values (14641) |
| Value | Count | Frequency (%) | |
| Point Cook - Point Cook | 49 | 0.2% | |
| Mildenhall - Mildenhall | 47 | 0.2% | |
| Waddington - Waddington | 47 | 0.2% | |
| Paris - Croydon | 44 | 0.2% | |
| Scampton - Scampton | 44 | 0.2% | |
| Coningsby - Coningsby | 43 | 0.2% | |
| Silloth - Silloth | 43 | 0.2% | |
| Moscow - Moscow | 35 | 0.1% | |
| Swinderby - Swinderby | 34 | 0.1% | |
| Kinloss - Kinloss | 32 | 0.1% | |
| Other values (14636) | 26550 | 98.4% |
Length
| Max length | 244 |
|---|---|
| Median length | 20 |
| Mean length | 22.81423115 |
| Min length | 3 |
| Distinct count | 17759 |
|---|---|
| Unique (%) | 65.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| 01 | 67 |
|---|---|
| 2 | 51 |
| 1 | 50 |
| 10 | 40 |
| 14 | 38 |
| Other values (17754) |
| Value | Count | Frequency (%) | |
| 01 | 67 | 0.2% | |
| 2 | 51 | 0.2% | |
| 1 | 50 | 0.2% | |
| 10 | 40 | 0.1% | |
| 14 | 38 | 0.1% | |
| 3 | 37 | 0.1% | |
| 15 | 33 | 0.1% | |
| 6 | 28 | 0.1% | |
| 25 | 28 | 0.1% | |
| 4 | 26 | 0.1% | |
| Other values (17749) | 26571 | 98.5% |
Length
| Max length | 17 |
|---|---|
| Median length | 5 |
| Mean length | 5.480588824 |
| Min length | 1 |
YOM
Real number (ℝ≥0)
| Distinct count | 104 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1955.4122511031185 |
|---|---|
| Minimum | 1911 |
| Maximum | 2018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 1911 |
|---|---|
| 5-th percentile | 1928 |
| Q1 | 1943 |
| median | 1951 |
| Q3 | 1970 |
| 95-th percentile | 1988 |
| Maximum | 2018 |
| Range | 107 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 19.0618194 |
|---|---|
| Coefficient of variation (CV) | 0.009748235641 |
| Kurtosis | -0.4784724193 |
| Mean | 1955.412251 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.4118138292 |
| Sum | 52735513 |
| Variance | 363.3529588 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1944 | 2778 | 10.3% | |
| 1943 | 1549 | 5.7% | |
| 1945 | 1149 | 4.3% | |
| 1941 | 817 | 3.0% | |
| 1942 | 711 | 2.6% | |
| 1928 | 598 | 2.2% | |
| 1969 | 570 | 2.1% | |
| 1968 | 551 | 2.0% | |
| 1974 | 468 | 1.7% | |
| 1940 | 456 | 1.7% | |
| Other values (94) | 17322 | 64.2% |
| Value | Count | Frequency (%) | |
| 1911 | 1 | < 0.1% | |
| 1913 | 2 | < 0.1% | |
| 1916 | 1 | < 0.1% | |
| 1918 | 46 | 0.2% | |
| 1919 | 182 | 0.7% |
| Value | Count | Frequency (%) | |
| 2018 | 3 | < 0.1% | |
| 2017 | 3 | < 0.1% | |
| 2016 | 5 | < 0.1% | |
| 2015 | 13 | < 0.1% | |
| 2014 | 9 | < 0.1% |
| Distinct count | 12845 |
|---|---|
| Unique (%) | 47.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Atlantic Ocean All World | 138 |
|---|---|
| Pacific Ocean All World | 132 |
| Russia All Russia | 102 |
| North Sea All World | 62 |
| Mediterranean Sea All World | 48 |
| Other values (12840) |
| Value | Count | Frequency (%) | |
| Atlantic Ocean All World | 138 | 0.5% | |
| Pacific Ocean All World | 132 | 0.5% | |
| Russia All Russia | 102 | 0.4% | |
| North Sea All World | 62 | 0.2% | |
| Mediterranean Sea All World | 48 | 0.2% | |
| Mexico All Mexico | 41 | 0.2% | |
| Croydon Surrey | 38 | 0.1% | |
| United Kingdom All United Kingdom | 37 | 0.1% | |
| Fort Lauderdale-Hollywood Florida | 37 | 0.1% | |
| Kunming Yunnan | 37 | 0.1% | |
| Other values (12835) | 26297 | 97.5% |
Length
| Max length | 92 |
|---|---|
| Median length | 23 |
| Mean length | 24.99080426 |
| Min length | 7 |
| Distinct count | 218 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| United States of America | |
|---|---|
| United Kingdom | 2167 |
| Russia | 1440 |
| Canada | 1314 |
| France | 811 |
| Other values (213) |
| Value | Count | Frequency (%) | |
| United States of America | 6337 | 23.5% | |
| United Kingdom | 2167 | 8.0% | |
| Russia | 1440 | 5.3% | |
| Canada | 1314 | 4.9% | |
| France | 811 | 3.0% | |
| Brazil | 717 | 2.7% | |
| Australia | 597 | 2.2% | |
| World | 597 | 2.2% | |
| Germany | 584 | 2.2% | |
| Colombia | 513 | 1.9% | |
| Other values (208) | 11892 | 44.1% |
Length
| Max length | 30 |
|---|---|
| Median length | 8 |
| Mean length | 11.93755794 |
| Min length | 4 |
Region
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| North America | |
|---|---|
| Europe | |
| Asia | |
| South America | |
| Africa | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| North America | 7666 | 28.4% | |
| Europe | 6236 | 23.1% | |
| Asia | 5497 | 20.4% | |
| South America | 2456 | 9.1% | |
| Africa | 1984 | 7.4% | |
| Oceania | 1276 | 4.7% | |
| Central America | 1200 | 4.4% | |
| World | 598 | 2.2% | |
| Antarctica | 56 | 0.2% |
Length
| Max length | 15 |
|---|---|
| Median length | 6 |
| Mean length | 8.653491045 |
| Min length | 4 |
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1318550928844227 |
|---|---|
| Minimum | 0 |
| Maximum | 1920 |
| Zeros | 3480 |
| Zeros (%) | 12.9% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 1920 |
| Range | 1920 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 12.03736754 |
|---|---|
| Coefficient of variation (CV) | 3.843526339 |
| Kurtosis | 23847.36687 |
| Mean | 3.131855093 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 149.7973589 |
| Sum | 84463 |
| Variance | 144.8982173 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 5962 | 22.1% | |
| 2 | 5496 | 20.4% | |
| 0 | 3480 | 12.9% | |
| 3 | 3100 | 11.5% | |
| 4 | 2649 | 9.8% | |
| 5 | 1875 | 7.0% | |
| 6 | 1341 | 5.0% | |
| 7 | 964 | 3.6% | |
| 8 | 654 | 2.4% | |
| 9 | 379 | 1.4% | |
| Other values (19) | 1069 | 4.0% |
| Value | Count | Frequency (%) | |
| 0 | 3480 | 12.9% | |
| 1 | 5962 | 22.1% | |
| 2 | 5496 | 20.4% | |
| 3 | 3100 | 11.5% | |
| 4 | 2649 | 9.8% |
| Value | Count | Frequency (%) | |
| 1920 | 1 | < 0.1% | |
| 107 | 1 | < 0.1% | |
| 48 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 25 | 1 | < 0.1% |
| Distinct count | 25 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6889391523601172 |
|---|---|
| Minimum | 0 |
| Maximum | 25 |
| Zeros | 13596 |
| Zeros (%) | 50.4% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.545561619 |
|---|---|
| Coefficient of variation (CV) | 1.507195576 |
| Kurtosis | 5.704845242 |
| Mean | 1.688939152 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.115337858 |
| Sum | 45549 |
| Variance | 6.479883957 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 13596 | 50.4% | |
| 1 | 3743 | 13.9% | |
| 2 | 2822 | 10.5% | |
| 3 | 1825 | 6.8% | |
| 4 | 1567 | 5.8% | |
| 5 | 1068 | 4.0% | |
| 6 | 695 | 2.6% | |
| 7 | 515 | 1.9% | |
| 8 | 364 | 1.3% | |
| 9 | 246 | 0.9% | |
| Other values (15) | 528 | 2.0% |
| Value | Count | Frequency (%) | |
| 0 | 13596 | 50.4% | |
| 1 | 3743 | 13.9% | |
| 2 | 2822 | 10.5% | |
| 3 | 1825 | 6.8% | |
| 4 | 1567 | 5.8% |
| Value | Count | Frequency (%) | |
| 25 | 1 | < 0.1% | |
| 23 | 3 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 21 | 2 | < 0.1% | |
| 20 | 1 | < 0.1% |
| Distinct count | 254 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.988987355853016 |
|---|---|
| Minimum | 0 |
| Maximum | 509 |
| Zeros | 14091 |
| Zeros (%) | 52.2% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 6 |
| 95-th percentile | 45 |
| Maximum | 509 |
| Range | 509 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 26.27983587 |
|---|---|
| Coefficient of variation (CV) | 2.92355911 |
| Kurtosis | 49.39493322 |
| Mean | 8.988987356 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.954956288 |
| Sum | 242424 |
| Variance | 690.6297734 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 14091 | 52.2% | |
| 1 | 1903 | 7.1% | |
| 2 | 1436 | 5.3% | |
| 3 | 1074 | 4.0% | |
| 4 | 919 | 3.4% | |
| 5 | 779 | 2.9% | |
| 6 | 556 | 2.1% | |
| 7 | 490 | 1.8% | |
| 8 | 453 | 1.7% | |
| 9 | 374 | 1.4% | |
| Other values (244) | 4894 | 18.1% |
| Value | Count | Frequency (%) | |
| 0 | 14091 | 52.2% | |
| 1 | 1903 | 7.1% | |
| 2 | 1436 | 5.3% | |
| 3 | 1074 | 4.0% | |
| 4 | 919 | 3.4% |
| Value | Count | Frequency (%) | |
| 509 | 1 | < 0.1% | |
| 451 | 1 | < 0.1% | |
| 384 | 1 | < 0.1% | |
| 381 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% |
| Distinct count | 181 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3811413103934145 |
|---|---|
| Minimum | 0 |
| Maximum | 506 |
| Zeros | 20401 |
| Zeros (%) | 75.6% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 17 |
| Maximum | 506 |
| Range | 506 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.72485116 |
|---|---|
| Coefficient of variation (CV) | 4.354994309 |
| Kurtosis | 165.6564741 |
| Mean | 3.38114131 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.36162094 |
| Sum | 91186 |
| Variance | 216.8212418 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 20401 | 75.6% | |
| 1 | 1261 | 4.7% | |
| 2 | 822 | 3.0% | |
| 3 | 575 | 2.1% | |
| 4 | 511 | 1.9% | |
| 5 | 374 | 1.4% | |
| 6 | 272 | 1.0% | |
| 7 | 234 | 0.9% | |
| 8 | 215 | 0.8% | |
| 9 | 171 | 0.6% | |
| Other values (171) | 2133 | 7.9% |
| Value | Count | Frequency (%) | |
| 0 | 20401 | 75.6% | |
| 1 | 1261 | 4.7% | |
| 2 | 822 | 3.0% | |
| 3 | 575 | 2.1% | |
| 4 | 511 | 1.9% |
| Value | Count | Frequency (%) | |
| 506 | 1 | < 0.1% | |
| 334 | 1 | < 0.1% | |
| 326 | 1 | < 0.1% | |
| 307 | 1 | < 0.1% | |
| 289 | 1 | < 0.1% |
| Distinct count | 40 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09781601097556454 |
|---|---|
| Minimum | 0 |
| Maximum | 237 |
| Zeros | 26634 |
| Zeros (%) | 98.8% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 237 |
| Range | 237 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.412807292 |
|---|---|
| Coefficient of variation (CV) | 24.66679297 |
| Kurtosis | 4989.150825 |
| Mean | 0.09781601098 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 61.95186755 |
| Sum | 2638 |
| Variance | 5.82163903 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 26634 | 98.8% | |
| 1 | 117 | 0.4% | |
| 2 | 48 | 0.2% | |
| 3 | 37 | 0.1% | |
| 4 | 26 | 0.1% | |
| 5 | 15 | 0.1% | |
| 6 | 13 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 10 | 8 | < 0.1% | |
| 8 | 7 | < 0.1% | |
| Other values (30) | 54 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 26634 | 98.8% | |
| 1 | 117 | 0.4% | |
| 2 | 48 | 0.2% | |
| 3 | 37 | 0.1% | |
| 4 | 26 | 0.1% |
| Value | Count | Frequency (%) | |
| 237 | 1 | < 0.1% | |
| 180 | 1 | < 0.1% | |
| 110 | 1 | < 0.1% | |
| 107 | 1 | < 0.1% | |
| 71 | 1 | < 0.1% |
| Distinct count | 201 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.806703993473989 |
|---|---|
| Minimum | 0 |
| Maximum | 520 |
| Zeros | 11108 |
| Zeros (%) | 41.2% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 5 |
| 95-th percentile | 24 |
| Maximum | 520 |
| Range | 520 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 17.10951531 |
|---|---|
| Coefficient of variation (CV) | 2.946510677 |
| Kurtosis | 117.8017019 |
| Mean | 5.806703993 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 8.755873054 |
| Sum | 156601 |
| Variance | 292.7355142 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 11108 | 41.2% | |
| 1 | 2658 | 9.9% | |
| 2 | 2458 | 9.1% | |
| 3 | 1775 | 6.6% | |
| 4 | 1566 | 5.8% | |
| 5 | 1263 | 4.7% | |
| 6 | 926 | 3.4% | |
| 7 | 746 | 2.8% | |
| 8 | 578 | 2.1% | |
| 9 | 439 | 1.6% | |
| Other values (191) | 3452 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 11108 | 41.2% | |
| 1 | 2658 | 9.9% | |
| 2 | 2458 | 9.1% | |
| 3 | 1775 | 6.6% | |
| 4 | 1566 | 5.8% |
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 346 | 1 | < 0.1% | |
| 335 | 1 | < 0.1% | |
| 329 | 1 | < 0.1% | |
| 312 | 1 | < 0.1% |
| Distinct count | 21207 |
|---|---|
| Unique (%) | 78.7% |
| Missing | 31 |
| Missing (%) | 0.1% |
| Memory size | 210.7 KiB |
| Engine failure. | 546 |
|---|---|
| Crashed in unknown circumstances. | 214 |
| Shot down by enemy fire. | 187 |
| Crash on a mountain 8 minutes after takeoff from Nausori Airport. All 17 occupants were killed. | 180 |
| Crashed in unknown circumstances in the Gulf of Mexico while completing a training mission. All three crew members, two pilots and an instructor, were killed. Crew: Cpt John Krafft, 1st Lt Ronald Pahl, Ltjg Robert Roch. | 157 |
| Other values (21202) |
| Value | Count | Frequency (%) | |
| Engine failure. | 546 | 2.0% | |
| Crashed in unknown circumstances. | 214 | 0.8% | |
| Shot down by enemy fire. | 187 | 0.7% | |
| Crash on a mountain 8 minutes after takeoff from Nausori Airport. All 17 occupants were killed. | 180 | 0.7% | |
| Crashed in unknown circumstances in the Gulf of Mexico while completing a training mission. All three crew members, two pilots and an instructor, were killed. Crew: Cpt John Krafft, 1st Lt Ronald Pahl, Ltjg Robert Roch. | 157 | 0.6% | |
| Fuel exhaustion. | 147 | 0.5% | |
| While flying off Florida coast, the pilot informed the controllers that he was low fuel and he ditched the aircraft 300 meters off shore. The board said that the fuel quantity on board was insufficient for the trip. | 123 | 0.5% | |
| Controlled flight into terrain. | 120 | 0.4% | |
| Shot down by the German Flak. | 116 | 0.4% | |
| It appears that the thrust reverser on left engine was engaged by mistake on approach. This was caused by a mechanical failure. | 113 | 0.4% | |
| Other values (21197) | 25035 | 92.8% |
Length
| Max length | 12209 |
|---|---|
| Median length | 197 |
| Mean length | 278.6239386 |
| Min length | 3 |
| Distinct count | 17590 |
|---|---|
| Unique (%) | 65.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| 1944-06-06 | 23 |
|---|---|
| 1943-05-17 | 17 |
| 1939-12-18 | 16 |
| 1945-03-24 | 16 |
| 1944-06-13 | 14 |
| Other values (17585) |
| Value | Count | Frequency (%) | |
| 1944-06-06 | 23 | 0.1% | |
| 1943-05-17 | 17 | 0.1% | |
| 1939-12-18 | 16 | 0.1% | |
| 1945-03-24 | 16 | 0.1% | |
| 1944-06-13 | 14 | 0.1% | |
| 1944-03-06 | 11 | < 0.1% | |
| 1944-09-17 | 11 | < 0.1% | |
| 1935-12-31 | 10 | < 0.1% | |
| 1944-05-25 | 10 | < 0.1% | |
| 1943-07-11 | 10 | < 0.1% | |
| Other values (17580) | 26831 | 99.5% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 7836 |
|---|---|
| Unique (%) | 29.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.7 KiB |
| Royal Air Force - RAF | 2247 |
|---|---|
| United States Air Force - USAF (since 1947) | 1443 |
| Aeroflot - Russian International Airlines | 1358 |
| United States Army Air Forces - USAAF (1941-1947) | 1350 |
| United States Navy - USN | 651 |
| Other values (7831) |
| Value | Count | Frequency (%) | |
| Royal Air Force - RAF | 2247 | 8.3% | |
| United States Air Force - USAF (since 1947) | 1443 | 5.4% | |
| Aeroflot - Russian International Airlines | 1358 | 5.0% | |
| United States Army Air Forces - USAAF (1941-1947) | 1350 | 5.0% | |
| United States Navy - USN | 651 | 2.4% | |
| Private American | 403 | 1.5% | |
| Royal Australian Air Force - RAAF | 267 | 1.0% | |
| French Air Force - Armée de l'Air | 191 | 0.7% | |
| Royal Canadian Air Force - RCAF | 175 | 0.6% | |
| Brazilian Air Force - Força Aérea Brasileira | 164 | 0.6% | |
| Other values (7826) | 18720 | 69.4% |
Length
| Max length | 90 |
|---|---|
| Median length | 24 |
| Mean length | 28.07504913 |
| Min length | 3 |
| Distinct count | 80 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.84953094293448 |
|---|---|
| Minimum | 0 |
| Maximum | 90 |
| Zeros | 1979 |
| Zeros (%) | 7.3% |
| Memory size | 210.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 8 |
| Q3 | 18 |
| 95-th percentile | 36 |
| Maximum | 90 |
| Range | 90 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 11.94262431 |
|---|---|
| Coefficient of variation (CV) | 1.007856291 |
| Kurtosis | 2.260631843 |
| Mean | 11.84953094 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.441895748 |
| Sum | 319570 |
| Variance | 142.6262755 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 2850 | 10.6% | |
| 2 | 2029 | 7.5% | |
| 0 | 1979 | 7.3% | |
| 3 | 1485 | 5.5% | |
| 4 | 1328 | 4.9% | |
| 5 | 1271 | 4.7% | |
| 6 | 1162 | 4.3% | |
| 7 | 1057 | 3.9% | |
| 8 | 962 | 3.6% | |
| 9 | 800 | 3.0% | |
| Other values (70) | 12046 | 44.7% |
| Value | Count | Frequency (%) | |
| 0 | 1979 | 7.3% | |
| 1 | 2850 | 10.6% | |
| 2 | 2029 | 7.5% | |
| 3 | 1485 | 5.5% | |
| 4 | 1328 | 4.9% |
| Value | Count | Frequency (%) | |
| 90 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 78 | 2 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 75 | 4 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| rowid | src_rowid | dt | df_index | Date & Time | Type of aircraft | Operator | Registration | Flight Phase | Flight Type | Survivors | Site | Schedule | MSN | YOM | Location | Country | Region | Crew on board | Crew fatalities | Pax on board | Pax fatalities | Other fatalities | Total fatalities | Circumstances | FlightDate | FlightOperator | PlaneAge | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 2020-09-20 14:38:01.180000 | 0 | Jul 15, 2020 at 2245 LT | Beechcraft 350 Super King Air | Turkish Police - Türk Polis (45115) | EM-809 | Flight | Survey / Patrol / Reconnaissance | No | Mountains | Van - Van | FL-896 | 2015 | Mt Artos\n\nEastern Anatolia Region (Dogu Anadolu Bölgesi) | Turkey | Asia | 2 | 2 | 5 | 5 | 0 | 7 | The twin engine aircraft departed Van-Ferit Melen Airport at 1834LT on a survey/reconnaissance mission over the province of Hakkari and Van, carrying five passengers and two pilots. At 2232LT, the crew informed ATC about his position vertical to Baskale on approach to Van-Ferit Melen Airport. Thirteen minutes later, the aircraft struck the slope of Mt Artos located 30 km southwest of runway 03 threshold. The aircraft was destroyed upon impact and all seven occupants were killed. | 2020-07-15 | Turkish Police - Türk Polis | 5 |
| 1 | 2 | 2 | 2020-09-20 14:38:01.893000 | 0 | Jul 14, 2020 | De Havilland DHC-8-400 (Dash-8) | Bluebird Aviation (35301) | 5Y-VVU | Landing (descent or approach) | Cargo | Yes | Airport (less than 10 km from airport) | Djibouti City – Beledweyne | 4008 | 2000 | Beledweyne-Haji-Sheikh Mahmud Hasan (Ugas Khalif)\n\nHiiraan (??????) | Somalia | Africa | 3 | 0 | 0 | 0 | 0 | 0 | After landing at Beledweyne-Haji-Sheikh Mahmud Hasan (Ugas Khalif) Airport, the aircraft went out of control and came to rest against several earth mounds, bursting into flames. All three crew members managed to escape while the aircraft was destroyed by fire. The crew was completing a cargo flight from Djibouti City on behalf of the African Union Mission to Somalia (AMISOM) and it is believed that the aircraft was carrying food supplies. | 2020-07-14 | Bluebird Aviation | 20 |
| 2 | 3 | 3 | 2020-09-20 14:38:02.533000 | 0 | Jul 13, 2020 at 0410 LT | PZL-Mielec AN-2 | Zeus-Avia (45102) | RA-40851 | Flight | Spraying (Agricultural) | No | Plain, Valley | Djibouti City – Beledweyne | 1G174-47 | 1977 | Kistenevo\n\nNizhny Novgorod oblast | Russia | Asia | 2 | 2 | 0 | 0 | 0 | 2 | The crew was completing a spraying mission near the village of Kistenovo (about 160 km southeast of Nizhny Novgorod). In unclear circumstances, it appears that the aircraft struck high tension wires then crashed in a field, bursting into flames. The captain was seriously injured while the copilot was killed. Two days later, the captain died from his injuries. | 2020-07-13 | Zeus-Avia | 43 |
| 3 | 4 | 4 | 2020-09-20 14:38:03.197000 | 0 | Jun 15, 2020 | Gulfstream GII | Private American (31833) | N27SL | Landing (descent or approach) | Illegal (smuggling) | Yes | Plain, Valley | Djibouti City – Beledweyne | 84 | 1970 | Machiques\n\nZulia | Venezuela | South America | 2 | 1 | 0 | 0 | 0 | 1 | The crew was engaged in an illegal trip and elected to land on a remote 'airstrip' located in the region of Machiques. The aircraft crash landed and came to rest, bursting into flames. One pilot was killed and the second was injured. | 2020-06-15 | Private American | 50 |
| 4 | 5 | 5 | 2020-09-20 14:38:03.823000 | 0 | Jun 14, 2020 | Embraer EMB-121 Xingu | Oeste Veículos (44860) | PT-MBV | Takeoff (climb) | Private | No | Airport (less than 10 km from airport) | Tangará da Serra – Goiânia | 121-053 | 1982 | Tangará da Serra\n\nMato Grosso | Brazil | South America | 2 | 2 | 0 | 0 | 0 | 2 | Shortly after takeoff, while in initial climb, the twin engine aircraft went out of control, lost altitude and crashed in a cornfield. The aircraft disintegrated on impact and both pilots were killed. | 2020-06-14 | Oeste Veículos | 38 |
| 5 | 6 | 6 | 2020-09-20 14:38:04.460000 | 0 | Jun 7, 2020 at 0415 LT | Mitsubishi MU-2 Marquise | McNeely Charter Service (32666) | N44MX | Takeoff (climb) | Cargo | No | Airport (less than 10 km from airport) | Everett – Huron | 1526 | 1981 | Sioux Falls\n\nSouth Dakota | United States of America | North America | 1 | 1 | 0 | 0 | 0 | 1 | The pilot departed Everett-Payne Field in the evening of June 6 on a cargo service to Huron, SD. En route, he was informed about the presence of thunderstorms in the Huron area and decided to divert to Sioux Falls Airport where he landed at 0140LT. Awaiting weather improvement, he left Sioux Falls around 0415LT to resume his flight to Huron. Upon takeoff, the twin engine aircraft crashed in unknown circumstances and was destroyed. The pilot was killed. | 2020-06-07 | McNeely Charter Service | 39 |
| 6 | 7 | 7 | 2020-09-20 14:38:05.067000 | 0 | Jun 5, 2020 at 1513 LT | Piper PA-31 Cheyenne | Larry Ray Pruitt (44800) | N135VE | Flight | Private | No | Plain, Valley | Williston – New Castle | 31-7520024 | 1975 | Eatonton\n\nGeorgia | United States of America | North America | 1 | 1 | 4 | 4 | 0 | 5 | The twin engine aircraft departed Willison Airport, Florida, at 1401LT bound for New Castle, Indiana, with four passengers and one pilot on board. Almost an hour into the flight, while cruising at an altitude of 25,000 feet, the aircraft entered a right turn then control was lost. While descending, the aircraft lost several pieces (wing parts) and caught fire before crashing in a wooded area located 6 miles northeast of Eatonton, bursting into flames. All five occupants were killed. They were on their way to funeral in Indiana. | 2020-06-05 | Larry Ray Pruitt | 45 |
| 7 | 8 | 8 | 2020-09-20 14:38:05.670000 | 0 | May 28, 2020 at 1543 LT | Rockwell Shrike Commander 500S | Alaska Department of Natural Resources (Division of Forestry) (41149) | N909AK | Takeoff (climb) | Survey / Patrol / Reconnaissance | Yes | Lake, Sea, Ocean, River | Aniak - Aniak | 500-3232 | 1975 | Aniak\n\nAlaska | United States of America | North America | 1 | 0 | 3 | 0 | 0 | 0 | After takeoff from Aniak Airport runway 10, the pilot encountered engine problems. Control was lost and the aircraft crashed in the Aniak River east of the airport. All four occupants were quickly rescued and medevaced to Anchorage. The aircraft was destroyed. | 2020-05-28 | Alaska Department of Natural Resources (Division of Forestry) | 45 |
| 8 | 9 | 9 | 2020-09-20 14:38:06.313000 | 0 | May 22, 2020 at 1439 LT | Airbus A320 | Pakistan International Airlines - PIA (31061) | AP-BLD | Landing (descent or approach) | Scheduled Revenue Flight | Yes | City | Lahore - Karachi | 2274 | 2004 | Karachi-Muhammad Ali Jinnah-Quaid-e-Azam\n\nSindh (??? ????) | Pakistan | Asia | 8 | 8 | 91 | 89 | 1 | 98 | On 22 May 2020 at 13:05 hrs PST, the Pakistan International Airlines aircraft Airbus A320-214, registration number AP-BLD, took off from Lahore (Allama Iqbal International Airport – AIIAP) Pakistan to perform a regular commercial passenger flight (PK8303) to Karachi (Jinnah International Airport – JIAP) Pakistan, with 8 crew members (01 Captain, 01 First Officer, and 06 flight attendants) and 91 passengers on board. At 14:35 hrs the aircraft performed an ILS approach for runway 25L and touched down without landing gears, resting on the engines. Both engines scrubbed the runway at high speed. Flight crew initiated a go-around and informed “Karachi Approach” that they intend to make a second approach. About four minutes later, during downwind leg, at an altitude of around 2000 ft, flight crew declared an emergency and stated that both engines had failed. The aircraft started losing altitude. It crashed in a populated area, short of runway 25L by about 1340 meters. An immediate subsequent post impact fire initiated. Out of 99 souls on-board, 97 were fatally injured and 02 passengers survived. On ground 04 persons were injured however 01 out of these reportedly expired later at a hospital.\n\r\nBelow, the preliminary report published by the Pakistan AAIB. | 2020-05-22 | Pakistan International Airlines - PIA | 16 |
| 9 | 10 | 10 | 2020-09-20 14:38:06.920000 | 0 | May 12, 2020 | Quest Kodiak 100 | Missionary Aviation Fellowship - MAF (31410) | PK-MEC | Takeoff (climb) | Cargo | No | Lake, Sea, Ocean, River | Jayapura - Mamit | 100-0026 | 2009 | Jayapura-Sentani\n\nSpecial Region of Papua | Indonesia | Asia | 1 | 1 | 0 | 0 | 0 | 1 | Shortly after takeoff from Jayapura-Sentani Airport, while climbing, the pilot sent a brief mayday message when he lost control of the airplane that crashed in Sentani Lake, two minutes after takeoff. The wreckage was found at a depth of 13 meters and the pilot, sole on board, was killed. | 2020-05-12 | Missionary Aviation Fellowship - MAF | 11 |
Last rows
| rowid | src_rowid | dt | df_index | Date & Time | Type of aircraft | Operator | Registration | Flight Phase | Flight Type | Survivors | Site | Schedule | MSN | YOM | Location | Country | Region | Crew on board | Crew fatalities | Pax on board | Pax fatalities | Other fatalities | Total fatalities | Circumstances | FlightDate | FlightOperator | PlaneAge | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26959 | 26961 | 26961 | 2020-09-20 23:43:40.330000 | 0 | Dec 8, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | 97 | Flight | Military | No | Plain, Valley | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | Brookeville\n\nMaryland | United States of America | North America | 1 | 0 | 0 | 0 | 0 | 0 | Pilot was performing a mail flight. He was killed in the accident which occurred in unknown circumstances. | 1918-12-08 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26960 | 26962 | 26962 | 2020-09-20 23:43:41.223000 | 0 | Dec 2, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | AS-22846 | Flight | Military | No | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | Wright-Patterson AFB (Dayton)\n\nOhio | United States of America | North America | 0 | 0 | 0 | 0 | 0 | 0 | The accident occurred in unknown circumstances. | 1918-12-02 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26961 | 26963 | 26963 | 2020-09-20 23:43:42.223000 | 0 | Nov 20, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | AS-39406 | Flight | Military | No | Plain, Valley | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | New Jersey\n\nNew Jersey | United States of America | North America | 0 | 0 | 0 | 0 | 0 | 0 | The accident occurred in unknown circumstances. | 1918-11-20 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26962 | 26964 | 26964 | 2020-09-20 23:43:43.420000 | 0 | Nov 12, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | SC-39168 | Flight | Military | No | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | Fort Worth\n\nTexas | United States of America | North America | 0 | 0 | 0 | 0 | 0 | 0 | The aircraft crashed in unknow circumstances near Everman-Barron Field airport. | 1918-11-12 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26963 | 26965 | 26965 | 2020-09-20 23:43:44.467000 | 0 | Nov 12, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | SC-39168 | Flight | Military | No | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | Detroit\n\nMichigan | United States of America | North America | 0 | 0 | 0 | 0 | 0 | 0 | The aircraft crashed in unknow circumstances near Everman-Barron Field airport. | 1918-11-12 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26964 | 26966 | 26966 | 2020-09-20 23:43:45.590000 | 0 | Nov 9, 1918 at 1200 LT | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | AS-23130 | Flight | Military | No | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | Langley AFB (Hampton)\n\nVirginia | United States of America | North America | 0 | 0 | 0 | 0 | 0 | 0 | The aircraft crashed in unknown circumstances. | 1918-11-09 | United States Signal Corps - USSC (1914-1919) | 0 |
| 26965 | 26967 | 26967 | 2020-09-20 23:43:46.667000 | 0 | Sep 13, 1918 at 1200 LT | De Havilland DH.9 | Royal Air Force - RAF (31257) | D1745 | Flight | Military | Yes | Plain, Valley | Seaton Carew AFB - Seaton Carew AFB | B9983 | 1918 | United Kingdom\n\nAll United Kingdom | United Kingdom | Europe | 1 | 0 | 0 | 0 | 0 | 0 | The pilot tried to return to his base but due to low visibility by night, he lost his orientation. He elected to make an emergency landing in an open field but the aircraft hit a tree and crashed. The pilot was injured. | 1918-09-13 | Royal Air Force - RAF | 0 |
| 26966 | 26968 | 26968 | 2020-09-20 23:43:47.813000 | 0 | Aug 26, 1918 | Blackburn RT.1 Kangaroo | Royal Air Force - RAF (31257) | B9976 | Landing (descent or approach) | Military | Yes | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9976 | 1918 | Seaton Carew AFB\n\nDurham | United Kingdom | Europe | 2 | 0 | 0 | 0 | 0 | 0 | On final approach in bad visibility, aircraft was too low. It struck the ground short of runway and crashed. Both occupants were injured. Crew was performing a training flight on behalf of the 246th Squadron. | 1918-08-26 | Royal Air Force - RAF | 0 |
| 26967 | 26969 | 26969 | 2020-09-20 23:43:48.787000 | 0 | Jun 24, 1918 at 1200 LT | Breguet 14 | French Air Force - Armée de l'Air (31256) | AS-4130 | Landing (descent or approach) | Military | Yes | Airport (less than 10 km from airport) | Seaton Carew AFB - Seaton Carew AFB | B9976 | 1918 | France\n\nAll France | France | Europe | 2 | 0 | 0 | 0 | 0 | 0 | The aircraft crashed in unknown circumstances. | 1918-06-24 | French Air Force - Armée de l'Air | 0 |
| 26968 | 26970 | 26970 | 2020-09-20 23:43:49.800000 | 0 | Jun 19, 1918 | De Havilland DH.4 | United States Signal Corps - USSC (1914-1919) (39326) | AS-32098 | Flight | Military | No | Airport (less than 10 km from airport) | Wright Patterson AFB-Wright Patterson AFB | B9976 | 1918 | Wright-Patterson AFB (Dayton)\n\nOhio | United States of America | North America | 1 | 1 | 0 | 0 | 0 | 1 | Lt. Frank Stuart Patterson, son and nephew of the co-founders of National Cash Register, is killed in the crash of his DH.4M, AS-32098, at Wilbur Wright Field during a flight test of a new mechanism for synchronizing machine gun and propeller, when a tie rod breaks during a dive from 15,000 feet (4,600 m), causing the wings to separate from the aircraft. Wishing to recognize the contributions of the Patterson family (owners of NCR) the area of Wright Field east of Huffman Dam (including Wilbur Wright Field, Fairfield Air Depot, and the Huffman Prairie) is renamed Patterson Field on 6 July 1931, in honor of Lt. Patterson. | 1918-06-19 | United States Signal Corps - USSC (1914-1919) | 0 |